OpenEdge Development:<br />ADM Reference setExternalTableList

Sets the ExternalTableList property (see webrprop.i), a pipe-separated list of comma-separated lists of External Tables that might be used to retrieve data for this request. In report and detail Web objects, this is specified on the External Tables and Objects Page in the QueryBuilder.

/* If you have a report of orders called reord.html you might call that report from any of the following types of objects: objects that provide ExternalTables=customer in the URL, along with information (rowid or foreign fields) that allow this report to retrieve only orders for a particular customer. objects that provide ExternalTables=salesrep,customer in the URL, along with information (rowids or foreign fields) that allow this report to retrieve only orders for a particular customer sold by a particular salesrep. objects that provide ExternalTables=salesrep in the URL, along with information (rowid or foreign fields) that allow this report to retrieve only orders sold by a particular salesrep. To allow external joins from any of these types of web objects, you would use the following call to setExternalTables: / setExternalTableList(’customer\|salesrep,customer\|salesrep’). / setForeignFieldList, setExternalJoinList and setExternalWhereList have corresponding pipe-delimited entries such as the following: */ setExternalJoinList (’OF customer\|Order.CustNum = Customer.CustNum AND Order.salesrep = Salesrep\|Order.salesrep = Salesrep’). setForeignFieldList (’custnum\|salesrep,custnum\|salesrep’). setExternalWhereList(’\|Order.PromiseDate < 12/12/99\|’)

/* If you have a report of orders called reord.html you might call that 
   report from any of the following types of objects: 
   objects that provide ExternalTables=customer in the URL, along with 
   information (rowid or foreign fields) that allow this report to 
   retrieve only orders for a particular customer. 
   objects that provide ExternalTables=salesrep,customer in the URL,  
   along with information (rowids or foreign fields) that allow this  
   report to retrieve only orders for a particular customer sold by a  
   particular salesrep. 
   objects that provide ExternalTables=salesrep in the URL, along with  
   information (rowid or foreign fields) that allow this report to  
   retrieve only orders sold by a particular salesrep. 
   To allow external joins from any of these types of web objects, you  
   would use the following call to setExternalTables: */ 
   setExternalTableList(’customer|salesrep,customer|salesrep’). 
/* setForeignFieldList, setExternalJoinList and setExternalWhereList have  
   corresponding pipe-delimited entries such as the following: */ 
setExternalJoinList 
   (’OF customer|Order.CustNum = Customer.CustNum AND 
   Order.salesrep = Salesrep|Order.salesrep = Salesrep’). 
   setForeignFieldList (’custnum|salesrep,custnum|salesrep’). 
   setExternalWhereList(’|Order.PromiseDate < 12/12/99|’)